Typing is ignored because a pick list is being displayed.
Cause:
This problem occurs because a pick list is being displayed.
Solution:
Microsoft has confirmed this to be a problem with Excel at this point. To work around it, press ESC to dismiss the pick list and then type the entry.
